PostgreSQL systemd

1 配置systemd 启动文件

#root>
vi /etc/systemd/system/postgresql.service
[Unit]
Description=PostgreSQL database server
Documentation=man:postgres(1)
After=network-online.target
Wants=network-online.target

[Service]
Type=notify
User=postgres
ExecStart=/usr/local/pgsql/bin/postgres -D /usr/local/pgsql/data
ExecReload=/bin/kill -HUP $MAINPID
KillMode=mixed
KillSignal=SIGINT
TimeoutSec=infinity

[Install]
WantedBy=multi-user.target

2 配置systemd 服务并开机自启

2.1 更新systemd 服务配置

#root>
systemctl daemon-reload

2.2 使用systemd 让postgresql 开机自启

#root>
systemctl enable postgresql